﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Docregdata2DataSet" targetNamespace="http://tempuri.org/Docregdata2DataSet.xsd" xmlns:mstns="http://tempuri.org/Docregdata2DataSet.xsd" xmlns="http://tempuri.org/Docregdata2DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="Docregdata2ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Docregdata2ConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TESTaddChildrow.My.MySettings.GlobalReference.Default.Docregdata2ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BedrijvenTableAdapter" GeneratorDataComponentClassName="BedrijvenTableAdapter" Name="Bedrijven" UserDataComponentName="BedrijvenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Bedrijven" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Bedrijven] WHERE (([BedrijvenID] = @Original_BedrijvenID) AND ((@IsNull_Timestamp = 1 AND [Timestamp] IS NULL) OR ([Timestamp] = @Original_Timestamp)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Bedrijven] ([Bedrijfsnaam], [Plaats], [Adres], [Postcode 1], [Postbus], [Postcode 2], [Telefoon], [Fax]) VALUES (@Bedrijfsnaam, @Plaats, @Adres, @Postcode_1, @Postbus, @Postcode_2, @Telefoon, @Fax);
SELECT BedrijvenID, Bedrijfsnaam, Plaats, Adres, [Postcode 1], Postbus, [Postcode 2], Telefoon, Fax, Timestamp FROM Bedrijven WHERE (BedrijvenID = SCOPE_IDENTITY()) ORDER BY Bedrijfsnaam</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bedrijfsnaam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bedrijfsnaam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Plaats" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Plaats" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adres" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postcode_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postcode 1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postbus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postbus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postcode_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postcode 2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefoon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT BedrijvenID, Bedrijfsnaam, Plaats, Adres, [Postcode 1], Postbus, [Postcode 2], Telefoon, Fax, Timestamp FROM Bedrijven ORDER BY Bedrijfsnaam</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Bedrijven] SET [Bedrijfsnaam] = @Bedrijfsnaam, [Plaats] = @Plaats, [Adres] = @Adres, [Postcode 1] = @Postcode_1, [Postbus] = @Postbus, [Postcode 2] = @Postcode_2, [Telefoon] = @Telefoon, [Fax] = @Fax WHERE (([BedrijvenID] = @Original_BedrijvenID) AND ((@IsNull_Timestamp = 1 AND [Timestamp] IS NULL) OR ([Timestamp] = @Original_Timestamp)));
SELECT BedrijvenID, Bedrijfsnaam, Plaats, Adres, [Postcode 1], Postbus, [Postcode 2], Telefoon, Fax, Timestamp FROM Bedrijven WHERE (BedrijvenID = @BedrijvenID) ORDER BY Bedrijfsnaam</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bedrijfsnaam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bedrijfsnaam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Plaats" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Plaats" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adres" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postcode_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postcode 1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postbus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postbus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Postcode_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Postcode 2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefoon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="BedrijvenID" ColumnName="BedrijvenID" DataSourceName="Docregdata2.dbo.Bedrijven" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BedrijvenID" DataSetColumn="BedrijvenID" />
              <Mapping SourceColumn="Bedrijfsnaam" DataSetColumn="Bedrijfsnaam" />
              <Mapping SourceColumn="Plaats" DataSetColumn="Plaats" />
              <Mapping SourceColumn="Adres" DataSetColumn="Adres" />
              <Mapping SourceColumn="Postcode 1" DataSetColumn="Postcode 1" />
              <Mapping SourceColumn="Postbus" DataSetColumn="Postbus" />
              <Mapping SourceColumn="Postcode 2" DataSetColumn="Postcode 2" />
              <Mapping SourceColumn="Telefoon" DataSetColumn="Telefoon" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Bedrijven" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBedrijven_werken" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillByBedrijven_werken" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByBedrijven_werken">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT bedrijven.BedrijvenID, Bedrijfsnaam, Plaats, Adres, [Postcode 1], Postbus, [Postcode 2], Telefoon, Fax from Bedrijven inner join Bedrijven_werken on bedrijven.bedrijvenid = Bedrijven_werken.bedrijvenid WHERE bedrijven_werken.werknummer=@werknummer ORDER BY Bedrijfsnaam</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="werknummer" ColumnName="Werknummer" DataSourceName="Docregdata2.dbo.Bedrijven_werken" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ContactenTableAdapter" GeneratorDataComponentClassName="ContactenTableAdapter" Name="Contacten" UserDataComponentName="ContactenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Contacten" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Contacten] WHERE (([ContactenID] = @Original_ContactenID) AND ((@IsNull_timestamp = 1 AND [timestamp] IS NULL) OR ([timestamp] = @Original_timestamp)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Contacten] ([Contactpersoon], [BedrijvenID], [Mobiele telefoon], [E-mail]) VALUES (@Contactpersoon, @BedrijvenID, @Mobiele_telefoon, @p1);
SELECT ContactenID, Contactpersoon, BedrijvenID, [Mobiele telefoon], [E-mail], timestamp FROM Contacten WHERE (ContactenID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Contactpersoon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contactpersoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Mobiele_telefoon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mobiele telefoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ContactenID, Contactpersoon, BedrijvenID, [Mobiele telefoon], [E-mail], timestamp FROM Contacten</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Contacten] SET [Contactpersoon] = @Contactpersoon, [BedrijvenID] = @BedrijvenID, [Mobiele telefoon] = @Mobiele_telefoon, [E-mail] = @p1 WHERE (([ContactenID] = @Original_ContactenID) AND ((@IsNull_timestamp = 1 AND [timestamp] IS NULL) OR ([timestamp] = @Original_timestamp)));
SELECT ContactenID, Contactpersoon, BedrijvenID, [Mobiele telefoon], [E-mail], timestamp FROM Contacten WHERE (ContactenID = @ContactenID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Contactpersoon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Contactpersoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Mobiele_telefoon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mobiele telefoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ContactenID" ColumnName="ContactenID" DataSourceName="Docregdata2.dbo.Contacten" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ContactenID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContactenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ContactenID" DataSetColumn="ContactenID" />
              <Mapping SourceColumn="Contactpersoon" DataSetColumn="Contactpersoon" />
              <Mapping SourceColumn="BedrijvenID" DataSetColumn="BedrijvenID" />
              <Mapping SourceColumn="Mobiele telefoon" DataSetColumn="Mobiele telefoon" />
              <Mapping SourceColumn="E-mail" DataSetColumn="E-mail" />
              <Mapping SourceColumn="timestamp" DataSetColumn="timestamp" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DatumsTableAdapter" GeneratorDataComponentClassName="DatumsTableAdapter" Name="Datums" UserDataComponentName="DatumsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Datums" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Datums] WHERE (([DatumID] = @Original_DatumID) AND ((@IsNull_timestamp = 1 AND [timestamp] IS NULL) OR ([timestamp] = @Original_timestamp)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DatumID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DatumID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Datums] ([Datum], [TekeningID], [Binnenkomst]) VALUES (@Datum, @TekeningID, @Binnenkomst);
SELECT DatumID, Datum, TekeningID, Binnenkomst, timestamp FROM Datums WHERE (DatumID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Datum" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TekeningID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TekeningID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Binnenkomst" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Binnenkomst" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT DatumID, Datum, TekeningID, Binnenkomst, timestamp FROM Datums</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Datums] SET [Datum] = @Datum, [TekeningID] = @TekeningID, [Binnenkomst] = @Binnenkomst WHERE (([DatumID] = @Original_DatumID) AND ((@IsNull_timestamp = 1 AND [timestamp] IS NULL) OR ([timestamp] = @Original_timestamp)));
SELECT DatumID, Datum, TekeningID, Binnenkomst, timestamp FROM Datums WHERE (DatumID = @DatumID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Datum" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TekeningID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TekeningID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Binnenkomst" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Binnenkomst" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DatumID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DatumID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="DatumID" ColumnName="DatumID" DataSourceName="Docregdata2.dbo.Datums" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DatumID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DatumID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DatumID" DataSetColumn="DatumID" />
              <Mapping SourceColumn="Datum" DataSetColumn="Datum" />
              <Mapping SourceColumn="TekeningID" DataSetColumn="TekeningID" />
              <Mapping SourceColumn="Binnenkomst" DataSetColumn="Binnenkomst" />
              <Mapping SourceColumn="timestamp" DataSetColumn="timestamp" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GebruikersTableAdapter" GeneratorDataComponentClassName="GebruikersTableAdapter" Name="Gebruikers" UserDataComponentName="GebruikersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Gebruikers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Gebruikers] WHERE (([GebruikersID] = @Original_GebruikersID) AND ([Gebruikersnaam] = @Original_Gebruikersnaam) AND ([Wachtwoord] = @Original_Wachtwoord) AND ([E-mail] = @p2) AND ((@IsNull_Functie = 1 AND [Functie] IS NULL) OR ([Functie] = @Original_Functie)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GebruikersID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GebruikersID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Gebruikersnaam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gebruikersnaam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Wachtwoord" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Functie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Gebruikers] ([Gebruikersnaam], [Wachtwoord], [E-mail], [Functie]) VALUES (@Gebruikersnaam, @Wachtwoord, @p1, @Functie);
SELECT GebruikersID, Gebruikersnaam, Wachtwoord, [E-mail], Functie FROM Gebruikers WHERE (GebruikersID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Gebruikersnaam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gebruikersnaam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Wachtwoord" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT GebruikersID, Gebruikersnaam, Wachtwoord, [E-mail], Functie FROM dbo.Gebruikers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Gebruikers] SET [Gebruikersnaam] = @Gebruikersnaam, [Wachtwoord] = @Wachtwoord, [E-mail] = @p1, [Functie] = @Functie WHERE (([GebruikersID] = @Original_GebruikersID) AND ([Gebruikersnaam] = @Original_Gebruikersnaam) AND ([Wachtwoord] = @Original_Wachtwoord) AND ([E-mail] = @p2) AND ((@IsNull_Functie = 1 AND [Functie] IS NULL) OR ([Functie] = @Original_Functie)));
SELECT GebruikersID, Gebruikersnaam, Wachtwoord, [E-mail], Functie FROM Gebruikers WHERE (GebruikersID = @GebruikersID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Gebruikersnaam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gebruikersnaam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Wachtwoord" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GebruikersID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GebruikersID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Gebruikersnaam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gebruikersnaam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Wachtwoord" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E-mail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Functie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="GebruikersID" ColumnName="GebruikersID" DataSourceName="Docregdata2.dbo.Gebruikers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GebruikersID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GebruikersID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GebruikersID" DataSetColumn="GebruikersID" />
              <Mapping SourceColumn="Gebruikersnaam" DataSetColumn="Gebruikersnaam" />
              <Mapping SourceColumn="Wachtwoord" DataSetColumn="Wachtwoord" />
              <Mapping SourceColumn="E-mail" DataSetColumn="E-mail" />
              <Mapping SourceColumn="Functie" DataSetColumn="Functie" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusTableAdapter" GeneratorDataComponentClassName="StatusTableAdapter" Name="Status" UserDataComponentName="StatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Status" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Status] ([StatusNaam], [DatumID]) VALUES (@StatusNaam, @DatumID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StatusNaam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StatusNaam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DatumID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DatumID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT StatusID, StatusNaam, DatumID, timestamp FROM Status</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="StatusNaam" DataSetColumn="StatusNaam" />
              <Mapping SourceColumn="DatumID" DataSetColumn="DatumID" />
              <Mapping SourceColumn="timestamp" DataSetColumn="timestamp" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TekeningenTableAdapter" GeneratorDataComponentClassName="TekeningenTableAdapter" Name="Tekeningen" UserDataComponentName="TekeningenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Tekeningen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Tekeningen] WHERE (([TekeningID] = @Original_TekeningID) AND ((@IsNull_timestamp = 1 AND [timestamp] IS NULL) OR ([timestamp] = @Original_timestamp)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TekeningID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TekeningID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Tekeningen] ([Naam], [Bladnummer], [BedrijvenID], [Werknummer], [Tekenkastnr]) VALUES (@Naam, @Bladnummer, @BedrijvenID, @Werknummer, @Tekenkastnr);
SELECT TekeningID, Naam, Bladnummer, BedrijvenID, Werknummer, Tekenkastnr, timestamp FROM Tekeningen WHERE (TekeningID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Naam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bladnummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bladnummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tekenkastnr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tekenkastnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TekeningID, Naam, Bladnummer, BedrijvenID, Werknummer, Tekenkastnr, timestamp FROM Tekeningen</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Tekeningen] SET [Naam] = @Naam, [Bladnummer] = @Bladnummer, [BedrijvenID] = @BedrijvenID, [Werknummer] = @Werknummer, [Tekenkastnr] = @Tekenkastnr WHERE (([TekeningID] = @Original_TekeningID) AND ((@IsNull_timestamp = 1 AND [timestamp] IS NULL) OR ([timestamp] = @Original_timestamp)));
SELECT TekeningID, Naam, Bladnummer, BedrijvenID, Werknummer, Tekenkastnr, timestamp FROM Tekeningen WHERE (TekeningID = @TekeningID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Naam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bladnummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bladnummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tekenkastnr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tekenkastnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TekeningID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TekeningID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TekeningID" ColumnName="TekeningID" DataSourceName="Docregdata2.dbo.Tekeningen" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TekeningID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TekeningID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TekeningID" DataSetColumn="TekeningID" />
              <Mapping SourceColumn="Naam" DataSetColumn="Naam" />
              <Mapping SourceColumn="Bladnummer" DataSetColumn="Bladnummer" />
              <Mapping SourceColumn="BedrijvenID" DataSetColumn="BedrijvenID" />
              <Mapping SourceColumn="Werknummer" DataSetColumn="Werknummer" />
              <Mapping SourceColumn="Tekenkastnr" DataSetColumn="Tekenkastnr" />
              <Mapping SourceColumn="timestamp" DataSetColumn="timestamp" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Tekeningen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TekeningID, Bladnummer, Naam, BedrijvenID, Werknummer, Tekenkastnr, timestamp FROM Tekeningen WHERE (Werknummer = @Werknummer)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Werknummer" ColumnName="Werknummer" DataSourceName="Docregdata2.dbo.Tekeningen" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TekeningenlijstTableAdapter" GeneratorDataComponentClassName="TekeningenlijstTableAdapter" Name="Tekeningenlijst" UserDataComponentName="TekeningenlijstTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Tekeningenlijst" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Tekeningenlijst] ([Bedrijfsnaam], [Bladnr], [Naam], [Datum1], [Datum2], [Datum3], [Datum4], [Datum5], [Datum6], [Datum7], [Datum8], [Datum9], [Datum10], [Status], [Tekenkastnr]) VALUES (@Bedrijfsnaam, @Bladnr, @Naam, @Datum1, @Datum2, @Datum3, @Datum4, @Datum5, @Datum6, @Datum7, @Datum8, @Datum9, @Datum10, @Status, @Tekenkastnr)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bedrijfsnaam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bedrijfsnaam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bladnr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bladnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Naam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum3" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum4" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum5" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum6" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum7" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum7" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum8" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum9" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Datum10" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Datum10" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tekenkastnr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tekenkastnr" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Bedrijfsnaam, Bladnr, Naam, Datum1, Datum2, Datum3, Datum4, Datum5, Datum6, Datum7, Datum8, Datum9, Datum10, Status, Tekenkastnr FROM Tekeningenlijst</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Bedrijfsnaam" DataSetColumn="Bedrijfsnaam" />
              <Mapping SourceColumn="Bladnr" DataSetColumn="Bladnr" />
              <Mapping SourceColumn="Naam" DataSetColumn="Naam" />
              <Mapping SourceColumn="Datum1" DataSetColumn="Datum1" />
              <Mapping SourceColumn="Datum2" DataSetColumn="Datum2" />
              <Mapping SourceColumn="Datum3" DataSetColumn="Datum3" />
              <Mapping SourceColumn="Datum4" DataSetColumn="Datum4" />
              <Mapping SourceColumn="Datum5" DataSetColumn="Datum5" />
              <Mapping SourceColumn="Datum6" DataSetColumn="Datum6" />
              <Mapping SourceColumn="Datum7" DataSetColumn="Datum7" />
              <Mapping SourceColumn="Datum8" DataSetColumn="Datum8" />
              <Mapping SourceColumn="Datum9" DataSetColumn="Datum9" />
              <Mapping SourceColumn="Datum10" DataSetColumn="Datum10" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="Tekenkastnr" DataSetColumn="Tekenkastnr" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WerkenTableAdapter" GeneratorDataComponentClassName="WerkenTableAdapter" Name="Werken" UserDataComponentName="WerkenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Werken" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Werken] ([Werknummer], [Werkomschrijving], [Plaats], [Architect], [Constructeur]) VALUES (@Werknummer, @Werkomschrijving, @Plaats, @Architect, @Constructeur)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Werkomschrijving" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Werkomschrijving" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Plaats" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Plaats" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Architect" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Architect" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Constructeur" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Constructeur" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Werknummer, Werkomschrijving, Plaats, Architect, Constructeur, timestamp FROM Werken</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Werknummer" DataSetColumn="Werknummer" />
              <Mapping SourceColumn="Werkomschrijving" DataSetColumn="Werkomschrijving" />
              <Mapping SourceColumn="Plaats" DataSetColumn="Plaats" />
              <Mapping SourceColumn="Architect" DataSetColumn="Architect" />
              <Mapping SourceColumn="Constructeur" DataSetColumn="Constructeur" />
              <Mapping SourceColumn="timestamp" DataSetColumn="timestamp" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Verzonden_Tekeningen2TableAdapter" GeneratorDataComponentClassName="Verzonden_Tekeningen2TableAdapter" Name="Verzonden_Tekeningen2" UserDataComponentName="Verzonden_Tekeningen2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Verzonden_Tekeningen2" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Verzonden_Tekeningen2] WHERE (([Verzonden_ID] = @Original_Verzonden_ID) AND ((@IsNull_timestamp = 1 AND [timestamp] IS NULL) OR ([timestamp] = @Original_timestamp)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Verzonden_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Verzonden_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Verzonden_Tekeningen2] ([TekeningID], [DatumID], [StatusID], [Verzonden_naar], [Verzenddatum], [Werknummer], [Retour_gevraagd], [Retour_binnen], [Bestandsnaam_verzendbrief]) VALUES (@TekeningID, @DatumID, @StatusID, @Verzonden_naar, @Verzenddatum, @Werknummer, @Retour_gevraagd, @Retour_binnen, @Bestandsnaam_verzendbrief);
SELECT Verzonden_ID, TekeningID, DatumID, StatusID, Verzonden_naar, Verzenddatum, Werknummer, Retour_gevraagd, Retour_binnen, Bestandsnaam_verzendbrief, timestamp FROM Verzonden_Tekeningen2 WHERE (Verzonden_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TekeningID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TekeningID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DatumID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DatumID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Verzonden_naar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Verzonden_naar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Verzenddatum" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Verzenddatum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Retour_gevraagd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Retour_gevraagd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Retour_binnen" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Retour_binnen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Bestandsnaam_verzendbrief" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Bestandsnaam_verzendbrief" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Verzonden_ID, TekeningID, DatumID, StatusID, Verzonden_naar, Verzenddatum, Werknummer, Retour_gevraagd, Retour_binnen, Bestandsnaam_verzendbrief, timestamp FROM Verzonden_Tekeningen2</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Verzonden_Tekeningen2] SET [TekeningID] = @TekeningID, [DatumID] = @DatumID, [StatusID] = @StatusID, [Verzonden_naar] = @Verzonden_naar, [Verzenddatum] = @Verzenddatum, [Werknummer] = @Werknummer, [Retour_gevraagd] = @Retour_gevraagd, [Retour_binnen] = @Retour_binnen, [Bestandsnaam_verzendbrief] = @Bestandsnaam_verzendbrief WHERE (([Verzonden_ID] = @Original_Verzonden_ID) AND ((@IsNull_timestamp = 1 AND [timestamp] IS NULL) OR ([timestamp] = @Original_timestamp)));
SELECT Verzonden_ID, TekeningID, DatumID, StatusID, Verzonden_naar, Verzenddatum, Werknummer, Retour_gevraagd, Retour_binnen, Bestandsnaam_verzendbrief, timestamp FROM Verzonden_Tekeningen2 WHERE (Verzonden_ID = @Verzonden_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TekeningID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TekeningID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DatumID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DatumID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Verzonden_naar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Verzonden_naar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Verzenddatum" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Verzenddatum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Retour_gevraagd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Retour_gevraagd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Retour_binnen" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Retour_binnen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Bestandsnaam_verzendbrief" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Bestandsnaam_verzendbrief" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Verzonden_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Verzonden_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Verzonden_ID" ColumnName="Verzonden_ID" DataSourceName="Docregdata2.dbo.Verzonden_Tekeningen2" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Verzonden_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Verzonden_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Verzonden_ID" DataSetColumn="Verzonden_ID" />
              <Mapping SourceColumn="TekeningID" DataSetColumn="TekeningID" />
              <Mapping SourceColumn="DatumID" DataSetColumn="DatumID" />
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="Verzonden_naar" DataSetColumn="Verzonden_naar" />
              <Mapping SourceColumn="Verzenddatum" DataSetColumn="Verzenddatum" />
              <Mapping SourceColumn="Werknummer" DataSetColumn="Werknummer" />
              <Mapping SourceColumn="Retour_gevraagd" DataSetColumn="Retour_gevraagd" />
              <Mapping SourceColumn="Retour_binnen" DataSetColumn="Retour_binnen" />
              <Mapping SourceColumn="Bestandsnaam_verzendbrief" DataSetColumn="Bestandsnaam_verzendbrief" />
              <Mapping SourceColumn="timestamp" DataSetColumn="timestamp" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Bedrijven_werkenTableAdapter" GeneratorDataComponentClassName="Bedrijven_werkenTableAdapter" Name="Bedrijven_werken" UserDataComponentName="Bedrijven_werkenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Docregdata2ConnectionString (MySettings)" DbObjectName="Docregdata2.dbo.Bedrijven_werken" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Bedrijven_werken] WHERE (([ID] = @Original_ID) AND ([BedrijvenID] = @Original_BedrijvenID) AND ([Werknummer] = @Original_Werknummer))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Bedrijven_werken] ([BedrijvenID], [Werknummer]) VALUES (@BedrijvenID, @Werknummer);
SELECT ID, BedrijvenID, Werknummer FROM Bedrijven_werken WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, BedrijvenID, Werknummer FROM dbo.Bedrijven_werken</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Bedrijven_werken] SET [BedrijvenID] = @BedrijvenID, [Werknummer] = @Werknummer WHERE (([ID] = @Original_ID) AND ([BedrijvenID] = @Original_BedrijvenID) AND ([Werknummer] = @Original_Werknummer));
SELECT ID, BedrijvenID, Werknummer FROM Bedrijven_werken WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BedrijvenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedrijvenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Werknummer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Werknummer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="Docregdata2.dbo.Bedrijven_werken" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="BedrijvenID" DataSetColumn="BedrijvenID" />
              <Mapping SourceColumn="Werknummer" DataSetColumn="Werknummer" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Docregdata2DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Docregdata2DataSet" msprop:Generator_DataSetName="Docregdata2DataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Bedrijven" msprop:Generator_UserTableName="Bedrijven" msprop:Generator_RowDeletedName="BedrijvenRowDeleted" msprop:Generator_RowChangedName="BedrijvenRowChanged" msprop:Generator_RowClassName="BedrijvenRow" msprop:Generator_RowChangingName="BedrijvenRowChanging" msprop:Generator_RowEvArgName="BedrijvenRowChangeEvent" msprop:Generator_RowEvHandlerName="BedrijvenRowChangeEventHandler" msprop:Generator_TableClassName="BedrijvenDataTable" msprop:Generator_TableVarName="tableBedrijven" msprop:Generator_RowDeletingName="BedrijvenRowDeleting" msprop:Generator_TablePropName="Bedrijven">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BedrijvenID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="BedrijvenID" msprop:Generator_ColumnPropNameInRow="BedrijvenID" msprop:Generator_ColumnVarNameInTable="columnBedrijvenID" msprop:Generator_ColumnPropNameInTable="BedrijvenIDColumn" type="xs:int" />
              <xs:element name="Bedrijfsnaam" msprop:Generator_UserColumnName="Bedrijfsnaam" msprop:Generator_ColumnPropNameInRow="Bedrijfsnaam" msprop:Generator_ColumnVarNameInTable="columnBedrijfsnaam" msprop:Generator_ColumnPropNameInTable="BedrijfsnaamColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Plaats" msprop:Generator_UserColumnName="Plaats" msprop:Generator_ColumnPropNameInRow="Plaats" msprop:Generator_ColumnVarNameInTable="columnPlaats" msprop:Generator_ColumnPropNameInTable="PlaatsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Adres" msprop:Generator_UserColumnName="Adres" msprop:Generator_ColumnPropNameInRow="Adres" msprop:Generator_ColumnVarNameInTable="columnAdres" msprop:Generator_ColumnPropNameInTable="AdresColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postcode_x0020_1" msprop:Generator_UserColumnName="Postcode 1" msprop:Generator_ColumnPropNameInRow="Postcode_1" msprop:Generator_ColumnVarNameInTable="columnPostcode_1" msprop:Generator_ColumnPropNameInTable="Postcode_1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postbus" msprop:Generator_UserColumnName="Postbus" msprop:Generator_ColumnPropNameInRow="Postbus" msprop:Generator_ColumnVarNameInTable="columnPostbus" msprop:Generator_ColumnPropNameInTable="PostbusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postcode_x0020_2" msprop:Generator_UserColumnName="Postcode 2" msprop:Generator_ColumnPropNameInRow="Postcode_2" msprop:Generator_ColumnVarNameInTable="columnPostcode_2" msprop:Generator_ColumnPropNameInTable="Postcode_2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefoon" msprop:Generator_UserColumnName="Telefoon" msprop:Generator_ColumnPropNameInRow="Telefoon" msprop:Generator_ColumnVarNameInTable="columnTelefoon" msprop:Generator_ColumnPropNameInTable="TelefoonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax" msprop:Generator_UserColumnName="Fax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInTable="FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Contacten" msprop:Generator_UserTableName="Contacten" msprop:Generator_RowDeletedName="ContactenRowDeleted" msprop:Generator_RowChangedName="ContactenRowChanged" msprop:Generator_RowClassName="ContactenRow" msprop:Generator_RowChangingName="ContactenRowChanging" msprop:Generator_RowEvArgName="ContactenRowChangeEvent" msprop:Generator_RowEvHandlerName="ContactenRowChangeEventHandler" msprop:Generator_TableClassName="ContactenDataTable" msprop:Generator_TableVarName="tableContacten" msprop:Generator_RowDeletingName="ContactenRowDeleting" msprop:Generator_TablePropName="Contacten">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ContactenID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ContactenID" msprop:Generator_ColumnPropNameInRow="ContactenID" msprop:Generator_ColumnVarNameInTable="columnContactenID" msprop:Generator_ColumnPropNameInTable="ContactenIDColumn" type="xs:int" />
              <xs:element name="Contactpersoon" msprop:Generator_UserColumnName="Contactpersoon" msprop:Generator_ColumnPropNameInRow="Contactpersoon" msprop:Generator_ColumnVarNameInTable="columnContactpersoon" msprop:Generator_ColumnPropNameInTable="ContactpersoonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BedrijvenID" msprop:Generator_UserColumnName="BedrijvenID" msprop:Generator_ColumnPropNameInRow="BedrijvenID" msprop:Generator_ColumnVarNameInTable="columnBedrijvenID" msprop:Generator_ColumnPropNameInTable="BedrijvenIDColumn" type="xs:int" />
              <xs:element name="Mobiele_x0020_telefoon" msprop:Generator_UserColumnName="Mobiele telefoon" msprop:Generator_ColumnPropNameInRow="Mobiele_telefoon" msprop:Generator_ColumnVarNameInTable="columnMobiele_telefoon" msprop:Generator_ColumnPropNameInTable="Mobiele_telefoonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E-mail" msprop:Generator_UserColumnName="E-mail" msprop:Generator_ColumnPropNameInRow="_E_mail" msprop:Generator_ColumnVarNameInTable="_columnE_mail" msprop:Generator_ColumnPropNameInTable="_E_mailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="timestamp" msprop:Generator_ColumnVarNameInTable="columntimestamp" msprop:Generator_ColumnPropNameInRow="timestamp" msprop:Generator_ColumnPropNameInTable="timestampColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Datums" msprop:Generator_UserTableName="Datums" msprop:Generator_RowDeletedName="DatumsRowDeleted" msprop:Generator_RowChangedName="DatumsRowChanged" msprop:Generator_RowClassName="DatumsRow" msprop:Generator_RowChangingName="DatumsRowChanging" msprop:Generator_RowEvArgName="DatumsRowChangeEvent" msprop:Generator_RowEvHandlerName="DatumsRowChangeEventHandler" msprop:Generator_TableClassName="DatumsDataTable" msprop:Generator_TableVarName="tableDatums" msprop:Generator_RowDeletingName="DatumsRowDeleting" msprop:Generator_TablePropName="Datums">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DatumID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="DatumID" msprop:Generator_ColumnPropNameInRow="DatumID" msprop:Generator_ColumnVarNameInTable="columnDatumID" msprop:Generator_ColumnPropNameInTable="DatumIDColumn" type="xs:int" />
              <xs:element name="Datum" msprop:Generator_UserColumnName="Datum" msprop:Generator_ColumnPropNameInRow="Datum" msprop:Generator_ColumnVarNameInTable="columnDatum" msprop:Generator_ColumnPropNameInTable="DatumColumn" type="xs:dateTime" />
              <xs:element name="TekeningID" msprop:Generator_UserColumnName="TekeningID" msprop:Generator_ColumnPropNameInRow="TekeningID" msprop:Generator_ColumnVarNameInTable="columnTekeningID" msprop:Generator_ColumnPropNameInTable="TekeningIDColumn" type="xs:int" />
              <xs:element name="Binnenkomst" msprop:Generator_UserColumnName="Binnenkomst" msprop:Generator_ColumnPropNameInRow="Binnenkomst" msprop:Generator_ColumnVarNameInTable="columnBinnenkomst" msprop:Generator_ColumnPropNameInTable="BinnenkomstColumn" type="xs:dateTime" />
              <xs:element name="timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="timestamp" msprop:Generator_ColumnVarNameInTable="columntimestamp" msprop:Generator_ColumnPropNameInRow="timestamp" msprop:Generator_ColumnPropNameInTable="timestampColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Gebruikers" msprop:Generator_UserTableName="Gebruikers" msprop:Generator_RowDeletedName="GebruikersRowDeleted" msprop:Generator_RowChangedName="GebruikersRowChanged" msprop:Generator_RowClassName="GebruikersRow" msprop:Generator_RowChangingName="GebruikersRowChanging" msprop:Generator_RowEvArgName="GebruikersRowChangeEvent" msprop:Generator_RowEvHandlerName="GebruikersRowChangeEventHandler" msprop:Generator_TableClassName="GebruikersDataTable" msprop:Generator_TableVarName="tableGebruikers" msprop:Generator_RowDeletingName="GebruikersRowDeleting" msprop:Generator_TablePropName="Gebruikers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GebruikersID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="GebruikersID" msprop:Generator_ColumnPropNameInRow="GebruikersID" msprop:Generator_ColumnVarNameInTable="columnGebruikersID" msprop:Generator_ColumnPropNameInTable="GebruikersIDColumn" type="xs:int" />
              <xs:element name="Gebruikersnaam" msprop:Generator_UserColumnName="Gebruikersnaam" msprop:Generator_ColumnPropNameInRow="Gebruikersnaam" msprop:Generator_ColumnVarNameInTable="columnGebruikersnaam" msprop:Generator_ColumnPropNameInTable="GebruikersnaamColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Wachtwoord" msprop:Generator_UserColumnName="Wachtwoord" msprop:Generator_ColumnPropNameInRow="Wachtwoord" msprop:Generator_ColumnVarNameInTable="columnWachtwoord" msprop:Generator_ColumnPropNameInTable="WachtwoordColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E-mail" msprop:Generator_UserColumnName="E-mail" msprop:Generator_ColumnPropNameInRow="_E_mail" msprop:Generator_ColumnVarNameInTable="_columnE_mail" msprop:Generator_ColumnPropNameInTable="_E_mailColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Functie" msprop:Generator_UserColumnName="Functie" msprop:Generator_ColumnPropNameInRow="Functie" msprop:Generator_ColumnVarNameInTable="columnFunctie" msprop:Generator_ColumnPropNameInTable="FunctieColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Status" msprop:Generator_UserTableName="Status" msprop:Generator_RowDeletedName="StatusRowDeleted" msprop:Generator_RowChangedName="StatusRowChanged" msprop:Generator_RowClassName="StatusRow" msprop:Generator_RowChangingName="StatusRowChanging" msprop:Generator_RowEvArgName="StatusRowChangeEvent" msprop:Generator_RowEvHandlerName="StatusRowChangeEventHandler" msprop:Generator_TableClassName="StatusDataTable" msprop:Generator_TableVarName="tableStatus" msprop:Generator_RowDeletingName="StatusRowDeleting" msprop:Generator_TablePropName="Status">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StatusID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="StatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" type="xs:int" />
              <xs:element name="StatusNaam" msprop:Generator_UserColumnName="StatusNaam" msprop:Generator_ColumnPropNameInRow="StatusNaam" msprop:Generator_ColumnVarNameInTable="columnStatusNaam" msprop:Generator_ColumnPropNameInTable="StatusNaamColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DatumID" msprop:Generator_UserColumnName="DatumID" msprop:Generator_ColumnPropNameInRow="DatumID" msprop:Generator_ColumnVarNameInTable="columnDatumID" msprop:Generator_ColumnPropNameInTable="DatumIDColumn" type="xs:int" />
              <xs:element name="timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="timestamp" msprop:Generator_ColumnVarNameInTable="columntimestamp" msprop:Generator_ColumnPropNameInRow="timestamp" msprop:Generator_ColumnPropNameInTable="timestampColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tekeningen" msprop:Generator_UserTableName="Tekeningen" msprop:Generator_RowDeletedName="TekeningenRowDeleted" msprop:Generator_RowChangedName="TekeningenRowChanged" msprop:Generator_RowClassName="TekeningenRow" msprop:Generator_RowChangingName="TekeningenRowChanging" msprop:Generator_RowEvArgName="TekeningenRowChangeEvent" msprop:Generator_RowEvHandlerName="TekeningenRowChangeEventHandler" msprop:Generator_TableClassName="TekeningenDataTable" msprop:Generator_TableVarName="tableTekeningen" msprop:Generator_RowDeletingName="TekeningenRowDeleting" msprop:Generator_TablePropName="Tekeningen">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TekeningID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="TekeningID" msprop:Generator_ColumnPropNameInRow="TekeningID" msprop:Generator_ColumnVarNameInTable="columnTekeningID" msprop:Generator_ColumnPropNameInTable="TekeningIDColumn" type="xs:int" />
              <xs:element name="Naam" msprop:Generator_UserColumnName="Naam" msprop:Generator_ColumnPropNameInRow="Naam" msprop:Generator_ColumnVarNameInTable="columnNaam" msprop:Generator_ColumnPropNameInTable="NaamColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bladnummer" msprop:Generator_UserColumnName="Bladnummer" msprop:Generator_ColumnPropNameInRow="Bladnummer" msprop:Generator_ColumnVarNameInTable="columnBladnummer" msprop:Generator_ColumnPropNameInTable="BladnummerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BedrijvenID" msprop:Generator_UserColumnName="BedrijvenID" msprop:Generator_ColumnPropNameInRow="BedrijvenID" msprop:Generator_ColumnVarNameInTable="columnBedrijvenID" msprop:Generator_ColumnPropNameInTable="BedrijvenIDColumn" type="xs:int" />
              <xs:element name="Werknummer" msprop:Generator_UserColumnName="Werknummer" msprop:Generator_ColumnPropNameInRow="Werknummer" msprop:Generator_ColumnVarNameInTable="columnWerknummer" msprop:Generator_ColumnPropNameInTable="WerknummerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tekenkastnr" msprop:Generator_UserColumnName="Tekenkastnr" msprop:Generator_ColumnPropNameInRow="Tekenkastnr" msprop:Generator_ColumnVarNameInTable="columnTekenkastnr" msprop:Generator_ColumnPropNameInTable="TekenkastnrColumn" type="xs:int" minOccurs="0" />
              <xs:element name="timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="timestamp" msprop:Generator_ColumnVarNameInTable="columntimestamp" msprop:Generator_ColumnPropNameInRow="timestamp" msprop:Generator_ColumnPropNameInTable="timestampColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tekeningenlijst" msprop:Generator_UserTableName="Tekeningenlijst" msprop:Generator_RowDeletedName="TekeningenlijstRowDeleted" msprop:Generator_RowChangedName="TekeningenlijstRowChanged" msprop:Generator_RowClassName="TekeningenlijstRow" msprop:Generator_RowChangingName="TekeningenlijstRowChanging" msprop:Generator_RowEvArgName="TekeningenlijstRowChangeEvent" msprop:Generator_RowEvHandlerName="TekeningenlijstRowChangeEventHandler" msprop:Generator_TableClassName="TekeningenlijstDataTable" msprop:Generator_TableVarName="tableTekeningenlijst" msprop:Generator_RowDeletingName="TekeningenlijstRowDeleting" msprop:Generator_TablePropName="Tekeningenlijst">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Bedrijfsnaam" msprop:Generator_UserColumnName="Bedrijfsnaam" msprop:Generator_ColumnPropNameInRow="Bedrijfsnaam" msprop:Generator_ColumnVarNameInTable="columnBedrijfsnaam" msprop:Generator_ColumnPropNameInTable="BedrijfsnaamColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bladnr" msprop:Generator_UserColumnName="Bladnr" msprop:Generator_ColumnPropNameInRow="Bladnr" msprop:Generator_ColumnVarNameInTable="columnBladnr" msprop:Generator_ColumnPropNameInTable="BladnrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Naam" msprop:Generator_UserColumnName="Naam" msprop:Generator_ColumnPropNameInRow="Naam" msprop:Generator_ColumnVarNameInTable="columnNaam" msprop:Generator_ColumnPropNameInTable="NaamColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum1" msprop:Generator_UserColumnName="Datum1" msprop:Generator_ColumnPropNameInRow="Datum1" msprop:Generator_ColumnVarNameInTable="columnDatum1" msprop:Generator_ColumnPropNameInTable="Datum1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum2" msprop:Generator_UserColumnName="Datum2" msprop:Generator_ColumnPropNameInRow="Datum2" msprop:Generator_ColumnVarNameInTable="columnDatum2" msprop:Generator_ColumnPropNameInTable="Datum2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum3" msprop:Generator_UserColumnName="Datum3" msprop:Generator_ColumnPropNameInRow="Datum3" msprop:Generator_ColumnVarNameInTable="columnDatum3" msprop:Generator_ColumnPropNameInTable="Datum3Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum4" msprop:Generator_UserColumnName="Datum4" msprop:Generator_ColumnPropNameInRow="Datum4" msprop:Generator_ColumnVarNameInTable="columnDatum4" msprop:Generator_ColumnPropNameInTable="Datum4Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum5" msprop:Generator_UserColumnName="Datum5" msprop:Generator_ColumnPropNameInRow="Datum5" msprop:Generator_ColumnVarNameInTable="columnDatum5" msprop:Generator_ColumnPropNameInTable="Datum5Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum6" msprop:Generator_UserColumnName="Datum6" msprop:Generator_ColumnPropNameInRow="Datum6" msprop:Generator_ColumnVarNameInTable="columnDatum6" msprop:Generator_ColumnPropNameInTable="Datum6Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum7" msprop:Generator_UserColumnName="Datum7" msprop:Generator_ColumnPropNameInRow="Datum7" msprop:Generator_ColumnVarNameInTable="columnDatum7" msprop:Generator_ColumnPropNameInTable="Datum7Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum8" msprop:Generator_UserColumnName="Datum8" msprop:Generator_ColumnPropNameInRow="Datum8" msprop:Generator_ColumnVarNameInTable="columnDatum8" msprop:Generator_ColumnPropNameInTable="Datum8Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum9" msprop:Generator_UserColumnName="Datum9" msprop:Generator_ColumnPropNameInRow="Datum9" msprop:Generator_ColumnVarNameInTable="columnDatum9" msprop:Generator_ColumnPropNameInTable="Datum9Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Datum10" msprop:Generator_UserColumnName="Datum10" msprop:Generator_ColumnPropNameInRow="Datum10" msprop:Generator_ColumnVarNameInTable="columnDatum10" msprop:Generator_ColumnPropNameInTable="Datum10Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tekenkastnr" msprop:Generator_UserColumnName="Tekenkastnr" msprop:Generator_ColumnVarNameInTable="columnTekenkastnr" msprop:Generator_ColumnPropNameInRow="Tekenkastnr" msprop:Generator_ColumnPropNameInTable="TekenkastnrColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Werken" msprop:Generator_UserTableName="Werken" msprop:Generator_RowDeletedName="WerkenRowDeleted" msprop:Generator_RowChangedName="WerkenRowChanged" msprop:Generator_RowClassName="WerkenRow" msprop:Generator_RowChangingName="WerkenRowChanging" msprop:Generator_RowEvArgName="WerkenRowChangeEvent" msprop:Generator_RowEvHandlerName="WerkenRowChangeEventHandler" msprop:Generator_TableClassName="WerkenDataTable" msprop:Generator_TableVarName="tableWerken" msprop:Generator_RowDeletingName="WerkenRowDeleting" msprop:Generator_TablePropName="Werken">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Werknummer" msprop:Generator_UserColumnName="Werknummer" msprop:Generator_ColumnPropNameInRow="Werknummer" msprop:Generator_ColumnVarNameInTable="columnWerknummer" msprop:Generator_ColumnPropNameInTable="WerknummerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Werkomschrijving" msprop:Generator_UserColumnName="Werkomschrijving" msprop:Generator_ColumnPropNameInRow="Werkomschrijving" msprop:Generator_ColumnVarNameInTable="columnWerkomschrijving" msprop:Generator_ColumnPropNameInTable="WerkomschrijvingColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Plaats" msprop:Generator_UserColumnName="Plaats" msprop:Generator_ColumnPropNameInRow="Plaats" msprop:Generator_ColumnVarNameInTable="columnPlaats" msprop:Generator_ColumnPropNameInTable="PlaatsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Architect" msprop:Generator_UserColumnName="Architect" msprop:Generator_ColumnPropNameInRow="Architect" msprop:Generator_ColumnVarNameInTable="columnArchitect" msprop:Generator_ColumnPropNameInTable="ArchitectColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Constructeur" msprop:Generator_UserColumnName="Constructeur" msprop:Generator_ColumnPropNameInRow="Constructeur" msprop:Generator_ColumnVarNameInTable="columnConstructeur" msprop:Generator_ColumnPropNameInTable="ConstructeurColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="timestamp" msprop:Generator_ColumnVarNameInTable="columntimestamp" msprop:Generator_ColumnPropNameInRow="timestamp" msprop:Generator_ColumnPropNameInTable="timestampColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Verzonden_Tekeningen2" msprop:Generator_UserTableName="Verzonden_Tekeningen2" msprop:Generator_RowDeletedName="Verzonden_Tekeningen2RowDeleted" msprop:Generator_RowChangedName="Verzonden_Tekeningen2RowChanged" msprop:Generator_RowClassName="Verzonden_Tekeningen2Row" msprop:Generator_RowChangingName="Verzonden_Tekeningen2RowChanging" msprop:Generator_RowEvArgName="Verzonden_Tekeningen2RowChangeEvent" msprop:Generator_RowEvHandlerName="Verzonden_Tekeningen2RowChangeEventHandler" msprop:Generator_TableClassName="Verzonden_Tekeningen2DataTable" msprop:Generator_TableVarName="tableVerzonden_Tekeningen2" msprop:Generator_RowDeletingName="Verzonden_Tekeningen2RowDeleting" msprop:Generator_TablePropName="Verzonden_Tekeningen2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Verzonden_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Verzonden_ID" msprop:Generator_ColumnPropNameInRow="Verzonden_ID" msprop:Generator_ColumnVarNameInTable="columnVerzonden_ID" msprop:Generator_ColumnPropNameInTable="Verzonden_IDColumn" type="xs:int" />
              <xs:element name="TekeningID" msprop:Generator_UserColumnName="TekeningID" msprop:Generator_ColumnPropNameInRow="TekeningID" msprop:Generator_ColumnVarNameInTable="columnTekeningID" msprop:Generator_ColumnPropNameInTable="TekeningIDColumn" type="xs:int" />
              <xs:element name="DatumID" msprop:Generator_UserColumnName="DatumID" msprop:Generator_ColumnPropNameInRow="DatumID" msprop:Generator_ColumnVarNameInTable="columnDatumID" msprop:Generator_ColumnPropNameInTable="DatumIDColumn" type="xs:int" />
              <xs:element name="StatusID" msprop:Generator_UserColumnName="StatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" type="xs:int" />
              <xs:element name="Verzonden_naar" msprop:Generator_UserColumnName="Verzonden_naar" msprop:Generator_ColumnPropNameInRow="Verzonden_naar" msprop:Generator_ColumnVarNameInTable="columnVerzonden_naar" msprop:Generator_ColumnPropNameInTable="Verzonden_naarColumn" type="xs:int" />
              <xs:element name="Verzenddatum" msprop:Generator_UserColumnName="Verzenddatum" msprop:Generator_ColumnPropNameInRow="Verzenddatum" msprop:Generator_ColumnVarNameInTable="columnVerzenddatum" msprop:Generator_ColumnPropNameInTable="VerzenddatumColumn" type="xs:dateTime" />
              <xs:element name="Werknummer" msprop:Generator_UserColumnName="Werknummer" msprop:Generator_ColumnPropNameInRow="Werknummer" msprop:Generator_ColumnVarNameInTable="columnWerknummer" msprop:Generator_ColumnPropNameInTable="WerknummerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Retour_gevraagd" msprop:Generator_UserColumnName="Retour_gevraagd" msprop:Generator_ColumnPropNameInRow="Retour_gevraagd" msprop:Generator_ColumnVarNameInTable="columnRetour_gevraagd" msprop:Generator_ColumnPropNameInTable="Retour_gevraagdColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Retour_binnen" msprop:Generator_UserColumnName="Retour_binnen" msprop:Generator_ColumnPropNameInRow="Retour_binnen" msprop:Generator_ColumnVarNameInTable="columnRetour_binnen" msprop:Generator_ColumnPropNameInTable="Retour_binnenColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Bestandsnaam_verzendbrief" msprop:Generator_UserColumnName="Bestandsnaam_verzendbrief" msprop:Generator_ColumnPropNameInRow="Bestandsnaam_verzendbrief" msprop:Generator_ColumnVarNameInTable="columnBestandsnaam_verzendbrief" msprop:Generator_ColumnPropNameInTable="Bestandsnaam_verzendbriefColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="timestamp" msdata:ReadOnly="true" msprop:Generator_UserColumnName="timestamp" msprop:Generator_ColumnVarNameInTable="columntimestamp" msprop:Generator_ColumnPropNameInRow="timestamp" msprop:Generator_ColumnPropNameInTable="timestampColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Bedrijven_werken" msprop:Generator_UserTableName="Bedrijven_werken" msprop:Generator_RowDeletedName="Bedrijven_werkenRowDeleted" msprop:Generator_RowChangedName="Bedrijven_werkenRowChanged" msprop:Generator_RowClassName="Bedrijven_werkenRow" msprop:Generator_RowChangingName="Bedrijven_werkenRowChanging" msprop:Generator_RowEvArgName="Bedrijven_werkenRowChangeEvent" msprop:Generator_RowEvHandlerName="Bedrijven_werkenRowChangeEventHandler" msprop:Generator_TableClassName="Bedrijven_werkenDataTable" msprop:Generator_TableVarName="tableBedrijven_werken" msprop:Generator_RowDeletingName="Bedrijven_werkenRowDeleting" msprop:Generator_TablePropName="Bedrijven_werken">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="BedrijvenID" msprop:Generator_UserColumnName="BedrijvenID" msprop:Generator_ColumnPropNameInRow="BedrijvenID" msprop:Generator_ColumnVarNameInTable="columnBedrijvenID" msprop:Generator_ColumnPropNameInTable="BedrijvenIDColumn" type="xs:int" />
              <xs:element name="Werknummer" msprop:Generator_UserColumnName="Werknummer" msprop:Generator_ColumnPropNameInRow="Werknummer" msprop:Generator_ColumnVarNameInTable="columnWerknummer" msprop:Generator_ColumnPropNameInTable="WerknummerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Bedrijven" />
      <xs:field xpath="mstns:BedrijvenID" />
    </xs:unique>
    <xs:unique name="Contacten_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Contacten" />
      <xs:field xpath="mstns:ContactenID" />
    </xs:unique>
    <xs:unique name="Datums_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Datums" />
      <xs:field xpath="mstns:DatumID" />
    </xs:unique>
    <xs:unique name="Gebruikers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Gebruikers" />
      <xs:field xpath="mstns:GebruikersID" />
    </xs:unique>
    <xs:unique name="Tekeningen_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tekeningen" />
      <xs:field xpath="mstns:TekeningID" />
    </xs:unique>
    <xs:unique name="Verzonden_Tekeningen2_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Verzonden_Tekeningen2" />
      <xs:field xpath="mstns:Verzonden_ID" />
    </xs:unique>
    <xs:unique name="Bedrijven_werken_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Bedrijven_werken" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Contacten_Bedrijven" msdata:parent="Bedrijven" msdata:child="Contacten" msdata:parentkey="BedrijvenID" msdata:childkey="BedrijvenID" msprop:Generator_UserRelationName="FK_Contacten_Bedrijven" msprop:Generator_RelationVarName="relationFK_Contacten_Bedrijven" msprop:Generator_UserChildTable="Contacten" msprop:Generator_UserParentTable="Bedrijven" msprop:Generator_ParentPropName="BedrijvenRow" msprop:Generator_ChildPropName="GetContactenRows" />
      <msdata:Relationship name="FK_Datums_Tekeningen" msdata:parent="Tekeningen" msdata:child="Datums" msdata:parentkey="TekeningID" msdata:childkey="TekeningID" msprop:Generator_UserRelationName="FK_Datums_Tekeningen" msprop:Generator_RelationVarName="relationFK_Datums_Tekeningen" msprop:Generator_UserChildTable="Datums" msprop:Generator_UserParentTable="Tekeningen" msprop:Generator_ParentPropName="TekeningenRow" msprop:Generator_ChildPropName="GetDatumsRows" />
      <msdata:Relationship name="FK_Status_Datums" msdata:parent="Datums" msdata:child="Status" msdata:parentkey="DatumID" msdata:childkey="DatumID" msprop:Generator_UserRelationName="FK_Status_Datums" msprop:Generator_RelationVarName="relationFK_Status_Datums" msprop:Generator_UserChildTable="Status" msprop:Generator_UserParentTable="Datums" msprop:Generator_ParentPropName="DatumsRow" msprop:Generator_ChildPropName="GetStatusRows" />
      <msdata:Relationship name="FK_Tekeningen_Bedrijven" msdata:parent="Bedrijven" msdata:child="Tekeningen" msdata:parentkey="BedrijvenID" msdata:childkey="BedrijvenID" msprop:Generator_UserRelationName="FK_Tekeningen_Bedrijven" msprop:Generator_RelationVarName="relationFK_Tekeningen_Bedrijven" msprop:Generator_UserChildTable="Tekeningen" msprop:Generator_UserParentTable="Bedrijven" msprop:Generator_ParentPropName="BedrijvenRow" msprop:Generator_ChildPropName="GetTekeningenRows" />
      <msdata:Relationship name="FK_Bedrijven_werken_Bedrijven" msdata:parent="Bedrijven" msdata:child="Bedrijven_werken" msdata:parentkey="BedrijvenID" msdata:childkey="BedrijvenID" msprop:Generator_UserRelationName="FK_Bedrijven_werken_Bedrijven" msprop:Generator_RelationVarName="relationFK_Bedrijven_werken_Bedrijven" msprop:Generator_UserChildTable="Bedrijven_werken" msprop:Generator_UserParentTable="Bedrijven" msprop:Generator_ParentPropName="BedrijvenRow" msprop:Generator_ChildPropName="GetBedrijven_werkenRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>